KANDA DATA

Descriptive statistical analysis is essential to carry out for your research data. From the output of descriptive statistics, you can obtain information such as the minimum, maximum, mean, standard deviation, standard error, and more. These values are important to interpret for each variable observed in your research.

There are many statistical software options that can help us perform descriptive statistics. However, Excel—something we are already familiar with in our daily activities—can also help us conduct descriptive statistical analysis quickly.

We can use the Data Analysis Tool provided by Excel to perform descriptive statistics. In this article, Kanda Data will share knowledge and a quick tutorial on how to perform descriptive statistics using Excel, even in under 1 minute.

Where to Find the Descriptive Statistics Menu in Excel

To perform descriptive statistics in Excel, we can use the Data Analysis Tool that comes with Excel. In addition to descriptive statistics, there are also many other statistical analysis options available. Here’s what the Data Analysis Tool looks like in Excel:

You can find this menu by clicking the Data ribbon, then in the upper right corner you will see the Data Analysis menu. If it’s not there, it means you need to activate the Data Analysis Toolpak by going to: File → Options → Add-ins → Go → Activate Data Analysis Toolpak.

Case Study Example

For practice in this article, I have prepared example data on product prices and sales. There are 10 products, named Product A through Product J in sequence. Each product has price data in rupiah and sales data in units. The detailed practice data for this article can be seen in the table below:

How to Perform Descriptive Statistics in Excel

The first step, of course, is to prepare the data. For this tutorial, we will use the example data on product prices and sales above.

Next, click the Data ribbon and, in the upper right corner, click Data Analysis. Once clicked, a list of available analysis options will appear. Look for Descriptive Statistics, and a new window will appear as shown below:

In the Input Range, select the data including labels for both the price and sales variables. Keep Grouped by as Columns. Then, check Labels in First Row. For Output Options, keep the output in the same sheet by selecting Output Range and choose the cell where you want the output to appear.

After that, enable Summary Statistics. You can also check other options according to your needs. The detailed setup can be seen in the figure below:

Once you click OK, the descriptive statistics output will appear as follows:

Based on this output, we can obtain descriptive statistics results including the mean, standard error, median, mode, standard deviation, sample variance, and more.

That’s the tutorial I can share in this article. I hope it’s useful and adds value for those who need it. Stay tuned for the next update from Kanda Data.